﻿//using System.Collections.Generic;
//using System.Data;
//using System.Data.SqlClient;
//using MyFloridaHouse.DataAccess.Extensions;
//using MyFloridaHouse.libSvDTO;

//namespace MyFloridaHouse.DataAccess
//{
//    public partial class DAL_CensusData
//    {

//        /// <summary>
//        /// Gets the file info. District plans are stored as blobs as named objects. This method returns
//        /// a list of info object that are used to populate a user screen control. The user select a plan
//        /// which is in turn passed to the FileSTO GetFile method as a parameter.
//        /// </summary>
//        /// <returns>List of <see cref="FileInfoDTO"/></returns>
//        /// <remarks>SPROC: usp_GetFileInfo</remarks>
//        public List<FileInfoDTO> GetFileInfo()
//        {
//            List<FileInfoDTO> itemList = new List<FileInfoDTO>();

//            //string storedProcedureName = "usp_GetFileInfo";
//            string storedProcedureName = "usp_tl10GetFileInfo10";

//            SqlConnection db = Connect();
//            SqlCommand StoredProcedureCommand = new SqlCommand(storedProcedureName, db);
//            StoredProcedureCommand.CommandType = CommandType.StoredProcedure;
//            db.Open();
//            using (SqlDataReader rdr = StoredProcedureCommand.ExecuteReader())
//            {
//                while (rdr.Read())
//                {
//                    itemList.Add(FileInfoDTODataContract.DataContract(rdr));
//                }
//            }
//            return itemList;
//        }
//    }
//}
